System error
| error: | DBD::mysql::st execute failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 64 at /home/femilia/lib2/UTL-V1.3/UTL/DB/UtilsDB.pm line 79. |
||||||||||||||||||||||
| context: |
|
||||||||||||||||||||||
| code stack: |
/home/femilia/lib2/UTL-V1.3/UTL/DB/UtilsDB.pm:79 /home/femilia/lib2/CYC-V3.0/CYC/WEB/DB/UserRecordsDB.pm:365 /home/femilia/www.femilia.com/htdocs/cycles/charts/autohandler:69 /home/femilia/www.femilia.com/htdocs/syshandler:75 |
DBD::mysql::st execute failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 64 at /home/femilia/lib2/UTL-V1.3/UTL/DB/UtilsDB.pm line 79.
Trace begun at /home/femilia/lib2//HTML/Mason/Exceptions.pm line 131
HTML::Mason::Exceptions::rethrow_exception('DBD::mysql::st execute failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near \'\' at line 64 at /home/femilia/lib2/UTL-V1.3/UTL/DB/UtilsDB.pm line 79.^J') called at /home/femilia/lib2/UTL-V1.3/UTL/DB/UtilsDB.pm line 79
UTL::DB::UtilsDB::select_multirow('UTL::DB::UtilsDB', 'DBI::db=HASH(0x860d318)', 'SELECT ur.record_id,^J ur.user_id,^J ur.thedate,^J YEAR( ur.thedate ) AS \'year\',^J MONTH( ur.thedate ) AS \'month\',^J MONTHNAME( ur.thedate ) AS \'monthname\',^J DATE_FORMAT( ur.thedate,"%b" ) AS \'shortmonthname\',^J DATE_FORMAT( ur.thedate, "%e/%m" ) AS \'dd/mm\',^J DATE_FORMAT( ur.thedate, "%m/%e" ) AS \'mm/dd\',^J DATE_FORMAT( ur.thedate, "%e %b" ) AS \'ddmon\',^J DAYOFMONTH( ur.thedate ) AS \'dayofmonth\',^J DAYOFWEEK( ur.thedate ) AS \'dayofweek\',^J DAYOFYEAR( ur.thedate ) AS \'dayofyear\',^J DAYNAME( ur.thedate ) AS \'dayname\',^J TO_DAYS( ur.thedate ) AS \'day\',^J ur.thedate AS \'date\',^J CASE^J WHEN (ur.cyclelength < (u.stat_actual_avg - (u.stat_stddev * 3)))^J THEN "INVALID"^J WHEN (ur.cyclelength > (u.stat_actual_avg + (u.stat_stddev * 3)))^J THEN "INVALID"^J WHEN (ur.cyclelength > u.pref_ignoremore)^J THEN "INVALID"^J WHEN (ur.cyclelength < u.pref_ignoreless)^J THEN "INVALID"^J ELSE^J "VALID"^J END AS \'status\',^J ur.firstday,^J ur.periodflow,^J ur.periodlength,^J ur.cyclelength,^J ur.bbtemperature,^J ur.cervicalmucus,^J ur.intercourse,^J ur.pregnancytest,^J ur.ovulationtest,^J ur.notes,^J CASE^J WHEN (ur.firstday IS NOT NULL)^J THEN "DATA"^J WHEN (ur.periodflow IS NOT NULL)^J THEN "DATA"^J WHEN (ur.bbtemperature IS NOT NULL)^J THEN "DATA"^J WHEN (ur.cervicalmucus IS NOT NULL)^J THEN "DATA"^J WHEN (ur.intercourse = \'Y\')^J THEN "DATA"^J WHEN (ur.pregnancytest IS NOT NULL)^J THEN "DATA"^J WHEN (ur.ovulationtest IS NOT NULL)^J THEN "DATA"^J WHEN (ur.notes IS NOT NULL)^J THEN "DATA"^J ELSE^J "NULL"^J END AS \'data\',^J ur.datetime_created,^J ur.datetime_updated^J FROM cyc_users u,^J cyc_user_records ur^J WHERE u.user_id = ur.user_id^J AND u.user_id = ', 'day') called at /home/femilia/lib2/CYC-V3.0/CYC/WEB/DB/UserRecordsDB.pm line 365
CYC::WEB::DB::UserRecordsDB::getUserRecordsByUser('CYC::WEB::DB::UserRecordsDB', 'DBI::db=HASH(0x860d318)', 'HASH(0x86f9cb4)') called at /home/femilia/www.femilia.com/htdocs/cycles/charts/autohandler line 69
HTML::Mason::Commands::__ANON__('keywords', 'hpt\u003dFWHCY\u0026Display__offset\u003d\u0026lu\u003d1625653929\u0026Chart__width\u003d520', 'dbh', 'DBI::db=HASH(0x860d318)', 'hashes', 'HASH(0x86f9504)', 'hr_site', 'HASH(0x860cf70)', 'hr_user', undef, 'hr_today', 'HASH(0x86f99f0)', 'hr_channel', 'HASH(0x86f9384)') called at /home/femilia/lib2//HTML/Mason/Component.pm line 134
HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x8645bb8)', 'keywords', 'hpt\u003dFWHCY\u0026Display__offset\u003d\u0026lu\u003d1625653929\u0026Chart__width\u003d520', 'dbh', 'DBI::db=HASH(0x860d318)', 'hashes', 'HASH(0x86f9504)', 'hr_site', 'HASH(0x860cf70)', 'hr_user', undef, 'hr_today', 'HASH(0x86f99f0)', 'hr_channel', 'HASH(0x86f9384)') called at /home/femilia/lib2//HTML/Mason/Request.pm line 1074
eval {...} at /home/femilia/lib2//HTML/Mason/Request.pm line 1068
HTML::Mason::Request::comp(undef, undef, 'keywords', 'hpt\u003dFWHCY\u0026Display__offset\u003d\u0026lu\u003d1625653929\u0026Chart__width\u003d520', 'dbh', 'DBI::db=HASH(0x860d318)', 'hashes', 'HASH(0x86f9504)', 'hr_site', 'HASH(0x860cf70)', 'hr_user', undef, 'hr_today', 'HASH(0x86f99f0)', 'hr_channel', 'HASH(0x86f9384)') called at /home/femilia/lib2//HTML/Mason/Request.pm line 760
HTML::Mason::Request::call_next('HTML::Mason::Request::CGI=HASH(0x855e908)', 'dbh', 'DBI::db=HASH(0x860d318)', 'hashes', 'HASH(0x86f9504)', 'hr_site', 'HASH(0x860cf70)', 'hr_user', undef, 'hr_today', 'HASH(0x86f99f0)', 'hr_channel', 'HASH(0x86f9384)') called at /home/femilia/www.femilia.com/htdocs/syshandler line 75
HTML::Mason::Commands::__ANON__('keywords', 'hpt\u003dFWHCY\u0026Display__offset\u003d\u0026lu\u003d1625653929\u0026Chart__width\u003d520') called at /home/femilia/lib2//HTML/Mason/Component.pm line 134
HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x86c35d4)', 'keywords', 'hpt\u003dFWHCY\u0026Display__offset\u003d\u0026lu\u003d1625653929\u0026Chart__width\u003d520') called at /home/femilia/lib2//HTML/Mason/Request.pm line 1069
eval {...} at /home/femilia/lib2//HTML/Mason/Request.pm line 1068
HTML::Mason::Request::comp(undef, undef, undef, 'keywords', 'hpt\u003dFWHCY\u0026Display__offset\u003d\u0026lu\u003d1625653929\u0026Chart__width\u003d520') called at /home/femilia/lib2//HTML/Mason/Request.pm line 338
eval {...} at /home/femilia/lib2//HTML/Mason/Request.pm line 338
eval {...} at /home/femilia/lib2//HTML/Mason/Request.pm line 297
HTML::Mason::Request::exec('HTML::Mason::Request::CGI=HASH(0x855e908)') called at /home/femilia/lib2//HTML/Mason/CGIHandler.pm line 197
eval {...} at /home/femilia/lib2//HTML/Mason/CGIHandler.pm line 197
HTML::Mason::Request::CGI::exec('HTML::Mason::Request::CGI=HASH(0x855e908)') called at /home/femilia/lib2//HTML/Mason/Interp.pm line 207
HTML::Mason::Interp::exec(undef, undef, 'keywords', 'hpt\u003dFWHCY\u0026Display__offset\u003d\u0026lu\u003d1625653929\u0026Chart__width\u003d520') called at /home/femilia/lib2//HTML/Mason/CGIHandler.pm line 127
eval {...} at /home/femilia/lib2//HTML/Mason/CGIHandler.pm line 127
HTML::Mason::CGIHandler::_handler('HTML::Mason::CGIHandler=HASH(0x81dad60)', 'HASH(0x804cb44)') called at /home/femilia/lib2//HTML/Mason/CGIHandler.pm line 66
HTML::Mason::CGIHandler::handle_request('HTML::Mason::CGIHandler=HASH(0x81dad60)') called at masonHandler.cgi line 28